COVID-19 has altered the world immeasurably. Schools and many workforces have been shift to become digitized and travel has been restricted. Mask use has been mandated by the government in many areas in the United States. With no end in sight of coronavirus cases dissipating, our group stems to give a visual presentation of COVID-19 incidence rates, as well as explore the correlation between tobacco use and COVID-19 incidence on difference ethnicity as a way to promote sources that promote equity.
The datasets we analyzed were taken from John Hopkins and Yahoo Finance. After combining these datasets, our data had 154 observations and 40 columns.
The coronavirus has reached 5,044,864 cases and 162,938 deaths since it’s inception in the United States. The worst day of COVID-19 had 4928 deaths in a single day. The most cases in a single day was 76,930 cases.
Since the first COVID-19 case in the U.S, the DOW JONES index has reached a low of 18,591.93 and a high of 29,551.42. The S&P 500 has reached a high of 3,386.15 and a low of 2,237.40.
The highest positive rate in a single day was 0.211 and the lowest tests per cases in a single day had reached 4.734.
This table shows a timeseries of COVID-19 cases in the United States from December 31st, 2019 to August 10th, 2020 in a month grouping. The table shows the total cases, deaths, and tests, in each month. The table also shows the average closing points of U.S market indices DOW JONES and S&P 500.
We can easily see which month had the most deaths, which also correlated to the lowest point on DOW JONES.
The table shows the slow beginning of the coronavirus has esclates exponentially within months. You can also see the market indices crash during the early onset of COVID-19, but recovering after DOW JONES reaches a low of 18591.93.
The table also shows how the number of tests being conducted each month is rapidly increasing, as the S&P 500 reaches near all time highs.
| Year | Month | total_cases | total_deaths | DOW_average | SPY_average | new_tests | positive_rate | tests_per_case |
|---|---|---|---|---|---|---|---|---|
| 2019 | 12 | 0 | 0 | 28538.44 | 3230.780 | 0 | NaN | NaN |
| 2020 | 1 | 5 | 0 | 28879.99 | 3278.203 | 0 | NaN | NaN |
| 2020 | 2 | 33 | 0 | 28519.73 | 3277.314 | 0 | NaN | NaN |
| 2020 | 3 | 111892 | 2062 | 22637.42 | 2652.394 | 794554 | 0.1121667 | 10.246167 |
| 2020 | 4 | 577137 | 40705 | 23293.90 | 2761.975 | 3654576 | 0.1790952 | 5.785048 |
| 2020 | 5 | 450083 | 28282 | 24271.02 | 2919.608 | 6944778 | 0.0784500 | 13.739550 |
| 2020 | 6 | 569508 | 16744 | 26062.27 | 3104.661 | 11056518 | 0.0515455 | 19.691364 |
| 2020 | 7 | 1342556 | 18814 | 26385.83 | 3207.619 | 16370782 | 0.0811818 | 12.378227 |
| 2020 | 8 | 310049 | 6170 | 27217.72 | 3331.633 | 3603396 | 0.0804000 | 12.461600 |
This is a bar chart that demonstrates the frequency of mask usages for the top five populous county in the United States. Looking at this chart and comparing it to the cases in each state. You can see the correlation of mask usage and number of COVID-19 incidence.